package com.ubst.smartad.impl.admin.account;

import java.sql.*;
import java.util.*;
import java.io.*;

import com.ubst.smartad.common.TimeUtil;
import com.ubst.smartad.logger.Debug;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Vector;

public class AccountMngImpl {
	
	Connection con = null;
	private String serverName;
	private Debug debug;
	//private FileHostEnv fhostEnv;


    /** 
     * 생성자
     *   
     *   
    */ 
	public AccountMngImpl(Connection con, String serverName, String log_level) {
		this.con = con;
		this.serverName = serverName;
		this.debug = new Debug("AccountMngImpl", log_level);
		//this.fhostEnv = FileHostEnv.getInstance(serverName);

	}

	
	/**
	 *  @author Kswany
	 * 	Account(계정) - account(linux계열) jqGrid List 가져오기
	 * 
	 *  searchStr: 검색조건
	 *  orderBy: sort조건
	 *  prev_page: first limit 
	 *  next_page: last limit
	 *  
	 * **/
	public List getJqgridAccountList_linux(String searchStr, String orderBy, int prev_page, int next_page) 
//			throws SQLException{
			throws Exception{
		PreparedStatement pstmt=null;
		ResultSet rs = null;

		HashMap log_data_map = null;
		List log_datas = new ArrayList();
		
		try{
		/*
		 *  DB value 값세팅 구현 로직 들어갈 부분
		 */
		// 가상데이터
		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("account", "avahi");
		log_data_map.put("status", "시스템계정");
		log_data_map.put("lock", "사용");
		log_data_map.put("expire_date", "2012-04-02");
		log_data_map.put("sync_time", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);
		
		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("account", "avahi");
		log_data_map.put("status", "시스템계정");
		log_data_map.put("lock", "사용");
		log_data_map.put("expire_date", "2012-04-02");
		log_data_map.put("sync_time", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("account", "avahi");
		log_data_map.put("status", "시스템계정");
		log_data_map.put("lock", "사용");
		log_data_map.put("expire_date", "2012-04-02");
		log_data_map.put("sync_time", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("account", "avahi");
		log_data_map.put("status", "시스템계정");
		log_data_map.put("lock", "사용");
		log_data_map.put("expire_date", "2012-04-02");
		log_data_map.put("sync_time", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("account", "avahi");
		log_data_map.put("status", "시스템계정");
		log_data_map.put("lock", "사용");
		log_data_map.put("expire_date", "2012-04-02");
		log_data_map.put("sync_time", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("account", "avahi");
		log_data_map.put("status", "시스템계정");
		log_data_map.put("lock", "사용");
		log_data_map.put("expire_date", "2012-04-02");
		log_data_map.put("sync_time", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("account", "avahi");
		log_data_map.put("status", "시스템계정");
		log_data_map.put("lock", "사용");
		log_data_map.put("expire_date", "2012-04-02");
		log_data_map.put("sync_time", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("account", "avahi");
		log_data_map.put("status", "시스템계정");
		log_data_map.put("lock", "사용");
		log_data_map.put("expire_date", "2012-04-02");
		log_data_map.put("sync_time", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("account", "avahi");
		log_data_map.put("status", "시스템계정");
		log_data_map.put("lock", "사용");
		log_data_map.put("expire_date", "2012-04-02");
		log_data_map.put("sync_time", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("account", "avahi");
		log_data_map.put("status", "시스템계정");
		log_data_map.put("lock", "사용");
		log_data_map.put("expire_date", "2012-04-02");
		log_data_map.put("sync_time", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("account", "avahi");
		log_data_map.put("status", "시스템계정");
		log_data_map.put("lock", "사용");
		log_data_map.put("expire_date", "2012-04-02");
		log_data_map.put("sync_time", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);
		
	//	}catch (SQLException e){
		}catch (Exception e){
			throw e;
		}finally{
	//		if ( rs != null) try{rs.close();}catch(SQLException ee){}
	//		if ( pstmt != null) try{pstmt.close();}catch(SQLException ee){}
		}
	
		return log_datas;
	}
	
	/**
	 *  @author Kswany
	 * 	Account(계정) - account(linux계열) Log jqGrid List 가져오기
	 * 
	 *  searchStr: 검색조건
	 *  orderBy: sort조건
	 *  prev_page: first limit 
	 *  next_page: last limit
	 *  
	 * **/
	public List getJqgridAccountLogList_linux(String searchStr, String orderBy, int prev_page, int next_page) 
//			throws SQLException{
			throws Exception{
		PreparedStatement pstmt=null;
		ResultSet rs = null;

		HashMap log_data_map = null;
		List log_datas = new ArrayList();
		
		try{	
		/*
		 *  DB value 값세팅 구현 로직 들어갈 부분
		 */
		// 가상데이터
		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리");
		log_data_map.put("work", "계정정책 변경");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보");
		log_data_map.put("worker", "adadmin");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);
		
		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-12 23:52:11");
		log_data_map.put("type", "계정관리22");
		log_data_map.put("work", "계정정책 변경22");
		log_data_map.put("result", "성공");
		log_data_map.put("important", "정보22");
		log_data_map.put("worker", "adadmin22");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리33");
		log_data_map.put("work", "계정정책 변경33");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보33");
		log_data_map.put("worker", "adadmin33");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리44");
		log_data_map.put("work", "계정정책 변경44");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보44");
		log_data_map.put("worker", "adadmin44");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리");
		log_data_map.put("work", "계정정책 변경");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보");
		log_data_map.put("worker", "adadmin");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리");
		log_data_map.put("work", "계정정책 변경");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보");
		log_data_map.put("worker", "adadmin");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리");
		log_data_map.put("work", "계정정책 변경");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보");
		log_data_map.put("worker", "adadmin");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리");
		log_data_map.put("work", "계정정책 변경");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보");
		log_data_map.put("worker", "adadmin");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리");
		log_data_map.put("work", "계정정책 변경");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보");
		log_data_map.put("worker", "adadmin");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리");
		log_data_map.put("work", "계정정책 변경");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보");
		log_data_map.put("worker", "adadmin");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리");
		log_data_map.put("work", "계정정책 변경");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보");
		log_data_map.put("worker", "adadmin");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);
		
	//	}catch (SQLException e){
		}catch (Exception e){
			throw e;
		}finally{
	//		if ( rs != null) try{rs.close();}catch(SQLException ee){}
	//		if ( pstmt != null) try{pstmt.close();}catch(SQLException ee){}
		}
	
		return log_datas;
	}
	
	/**
	 * @author : Kswany
	 * Account(계정) - account(linux계열) Info 가져오기 
	 *	key: system_name(가상설정)
	 */
	public HashMap getAccountInfo_linux(String system_name) 
//			throws SQLException {
			throws Exception{

		PreparedStatement pstmt=null;
		ResultSet rs = null;

		HashMap log_info_map = new HashMap();

		try {

			/*
			 *  DB value 값세팅 구현 로직 들어갈 부분
			 */
			// 가상데이터
			log_info_map.put("system_name", "Test001");
			log_info_map.put("id", "adadmin");
			log_info_map.put("group", "Group001");
			log_info_map.put("full_dir", "/var/adm");
			log_info_map.put("login_shell", "/sbin/nologin");
			log_info_map.put("pw_max_used_date", "99999");
			log_info_map.put("pw_min_used_date", "0");
			log_info_map.put("pw_expire_alarm_date", "7");
			log_info_map.put("expire_block_date", "0");
			log_info_map.put("lock_status", "해제");
			log_info_map.put("account_status", "시스템 계정");
			log_info_map.put("last_connect_gear", "TEST_gear");
			log_info_map.put("pw_change_date", "192.168.1.201");
			log_info_map.put("last_sync_date", "2013-04-02 16:11:17");
			
		}catch (Exception e){
			throw e;
		}finally{
//			if ( rs != null) try{rs.close();}catch(SQLException ee){}
//			if ( pstmt != null) try{pstmt.close();}catch(SQLException ee){}
		}
		
		
		return log_info_map;
	}
	
	/**
	 * @author : Kswany 
	 * Account(계정) - account(linux계열)  비밀번호 변경
	 *	key: pw(가상설정)
	 */
	public boolean updateAccountChangePw(String pw) 
	//	throws SQLException {
		throws Exception{
	
		PreparedStatement pstmt=null;
		ResultSet rs = null;
		
		boolean result = false;
		try {
		
			/*
			 *  DB value 값세팅 구현 로직 들어갈 부분(list의 key값들  where 조건 대입하여 삭제)
			 */
			// 가상데이터
			result = true;
		
		}catch (Exception e){
			throw e;
		}finally{
		//	if ( rs != null) try{rs.close();}catch(SQLException ee){}
		//	if ( pstmt != null) try{pstmt.close();}catch(SQLException ee){}
		}
		return result;
	}
	
	/**
	 * @author : Kswany 
	 * Account(계정) - account(linux계열) delete(list checkbox선택후 삭제, 리스트 마지막으로 클릭 한 상세정보에서 삭제)
	 *	key: checked된 key(가상설정)
	 */
	public boolean deleteAccount(List array) 
//			throws SQLException {
			throws Exception{

		PreparedStatement pstmt=null;
		ResultSet rs = null;

		boolean result = false;
		try {
	
			/*
			 *  DB value 값세팅 구현 로직 들어갈 부분(list의 key값들  where 조건 대입하여 삭제)
			 */
			// 가상데이터
			result = true;

		}catch (Exception e){
			throw e;
		}finally{
//			if ( rs != null) try{rs.close();}catch(SQLException ee){}
//			if ( pstmt != null) try{pstmt.close();}catch(SQLException ee){}
		}
		return result;
	}
	
	
	/**
	 * @author : Kswany 
	 *  Account(계정) - account(linux계열) - User insertAccountInfo
	 *	key: work_no(가상설정)
	 */
	public boolean insertAccountInfo(String work_no) 
//			throws SQLException {
			throws Exception{

		PreparedStatement pstmt=null;
		ResultSet rs = null;

		boolean result = false;
		try {

			/*
			 *  DB value 값세팅 구현 로직 들어갈 부분
			 */
			// 가상데이터
			result = true;

		}catch (Exception e){
			throw e;
		}finally{
//			if ( rs != null) try{rs.close();}catch(SQLException ee){}
//			if ( pstmt != null) try{pstmt.close();}catch(SQLException ee){}
		}
		return result;
	}
	
	/**
	 * @author : Kswany 
	 *  Account(계정) - account(linux계열) popup insert
	 *	key: system_name(가상설정)
	 */
	public boolean insertAccountAdd(HashMap param) 
//			throws SQLException {
			throws Exception{

		PreparedStatement pstmt=null;
		ResultSet rs = null;

		HashMap log_info_map = new HashMap();
		boolean result = false;
		try {

			String insert_system = String.valueOf(param.get("insert_system"));
			String id = String.valueOf(param.get("id"));
			String pw = String.valueOf(param.get("pw"));
			String pw_check = String.valueOf(param.get("pw_check"));
			String group = String.valueOf(param.get("group"));
			String login_shell = String.valueOf(param.get("login_shell"));
			String home_dir = String.valueOf(param.get("home_dir"));
			String used = String.valueOf(param.get("used"));
			String used_date = String.valueOf(param.get("used_date"));
				
			/*
			 *  DB value 값세팅 구현 로직 들어갈 부분
			 */
			// 가상데이터
			result = true;

		}catch (Exception e){
			throw e;
		}finally{
//			if ( rs != null) try{rs.close();}catch(SQLException ee){}
//			if ( pstmt != null) try{pstmt.close();}catch(SQLException ee){}
		}
		return result;
	}
	
	
	/**
	 * @author : Kswany 
	 *Account(계정) - account(linux계열)  ID 중복체크
	 *	key: group_name(가상설정)
	 */
	public boolean checkAccount(String id) 
	//	throws SQLException {
		throws Exception{
	
		PreparedStatement pstmt=null;
		ResultSet rs = null;
		
		boolean result = false;
		try {
		
			/*
			 *  DB value 값세팅 구현 로직 들어갈 부분(list의 key값들  where 조건 대입하여 삭제)
			 */
			// 가상데이터
			result = true;//사용할수 있을때 true, 없을때 false
		
		}catch (Exception e){
			throw e;
		}finally{
		//	if ( rs != null) try{rs.close();}catch(SQLException ee){}
		//	if ( pstmt != null) try{pstmt.close();}catch(SQLException ee){}
		}
		return result;
	}
	
	
	
	
	
	/**
	 *  @author Kswany
	 * 	Account(계정) - account(windows계열) jqGrid List 가져오기
	 * 
	 *  searchStr: 검색조건
	 *  orderBy: sort조건
	 *  prev_page: first limit 
	 *  next_page: last limit
	 *  
	 * **/      
	public List getJqgridAccountList_windows(String searchStr, String orderBy, int prev_page, int next_page) 
//			throws SQLException{
			throws Exception{
		PreparedStatement pstmt=null;
		ResultSet rs = null;

		HashMap log_data_map = null;
		List log_datas = new ArrayList();
		
		try{
		/*
		 *  DB value 값세팅 구현 로직 들어갈 부분
		 */
		// 가상데이터
		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("account", "avahi");
		log_data_map.put("status", "시스템계정");
		log_data_map.put("lock", "사용");
		log_data_map.put("expire_date", "2012-04-02");
		log_data_map.put("sync_time", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);
		
		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("account", "avahi");
		log_data_map.put("status", "시스템계정");
		log_data_map.put("lock", "사용");
		log_data_map.put("expire_date", "2012-04-02");
		log_data_map.put("sync_time", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("account", "avahi");
		log_data_map.put("status", "시스템계정");
		log_data_map.put("lock", "사용");
		log_data_map.put("expire_date", "2012-04-02");
		log_data_map.put("sync_time", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("account", "avahi");
		log_data_map.put("status", "시스템계정");
		log_data_map.put("lock", "사용");
		log_data_map.put("expire_date", "2012-04-02");
		log_data_map.put("sync_time", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("account", "avahi");
		log_data_map.put("status", "시스템계정");
		log_data_map.put("lock", "사용");
		log_data_map.put("expire_date", "2012-04-02");
		log_data_map.put("sync_time", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("account", "avahi");
		log_data_map.put("status", "시스템계정");
		log_data_map.put("lock", "사용");
		log_data_map.put("expire_date", "2012-04-02");
		log_data_map.put("sync_time", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("account", "avahi");
		log_data_map.put("status", "시스템계정");
		log_data_map.put("lock", "사용");
		log_data_map.put("expire_date", "2012-04-02");
		log_data_map.put("sync_time", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("account", "avahi");
		log_data_map.put("status", "시스템계정");
		log_data_map.put("lock", "사용");
		log_data_map.put("expire_date", "2012-04-02");
		log_data_map.put("sync_time", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("account", "avahi");
		log_data_map.put("status", "시스템계정");
		log_data_map.put("lock", "사용");
		log_data_map.put("expire_date", "2012-04-02");
		log_data_map.put("sync_time", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("account", "avahi");
		log_data_map.put("status", "시스템계정");
		log_data_map.put("lock", "사용");
		log_data_map.put("expire_date", "2012-04-02");
		log_data_map.put("sync_time", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("account", "avahi");
		log_data_map.put("status", "시스템계정");
		log_data_map.put("lock", "사용");
		log_data_map.put("expire_date", "2012-04-02");
		log_data_map.put("sync_time", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);
		
	//	}catch (SQLException e){
		}catch (Exception e){
			throw e;
		}finally{
	//		if ( rs != null) try{rs.close();}catch(SQLException ee){}
	//		if ( pstmt != null) try{pstmt.close();}catch(SQLException ee){}
		}
	
		return log_datas;
	}
	
	/**
	 *  @author Kswany
	 * 	Account(계정) - account(windows계열) Log jqGrid List 가져오기
	 * 
	 *  searchStr: 검색조건
	 *  orderBy: sort조건
	 *  prev_page: first limit 
	 *  next_page: last limit
	 *  
	 * **/
	public List getJqgridAccountLogList_windows(String searchStr, String orderBy, int prev_page, int next_page) 
//			throws SQLException{
			throws Exception{
		PreparedStatement pstmt=null;
		ResultSet rs = null;

		HashMap log_data_map = null;
		List log_datas = new ArrayList();
		
		try{	
		/*
		 *  DB value 값세팅 구현 로직 들어갈 부분
		 */
		// 가상데이터
		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리");
		log_data_map.put("work", "계정정책 변경");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보");
		log_data_map.put("worker", "adadmin");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);
		
		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-12 23:52:11");
		log_data_map.put("type", "계정관리22");
		log_data_map.put("work", "계정정책 변경22");
		log_data_map.put("result", "성공");
		log_data_map.put("important", "정보22");
		log_data_map.put("worker", "adadmin22");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리33");
		log_data_map.put("work", "계정정책 변경33");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보33");
		log_data_map.put("worker", "adadmin33");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리44");
		log_data_map.put("work", "계정정책 변경44");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보44");
		log_data_map.put("worker", "adadmin44");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리");
		log_data_map.put("work", "계정정책 변경");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보");
		log_data_map.put("worker", "adadmin");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리");
		log_data_map.put("work", "계정정책 변경");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보");
		log_data_map.put("worker", "adadmin");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리");
		log_data_map.put("work", "계정정책 변경");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보");
		log_data_map.put("worker", "adadmin");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리");
		log_data_map.put("work", "계정정책 변경");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보");
		log_data_map.put("worker", "adadmin");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리");
		log_data_map.put("work", "계정정책 변경");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보");
		log_data_map.put("worker", "adadmin");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리");
		log_data_map.put("work", "계정정책 변경");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보");
		log_data_map.put("worker", "adadmin");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리");
		log_data_map.put("work", "계정정책 변경");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보");
		log_data_map.put("worker", "adadmin");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);
		
	//	}catch (SQLException e){
		}catch (Exception e){
			throw e;
		}finally{
	//		if ( rs != null) try{rs.close();}catch(SQLException ee){}
	//		if ( pstmt != null) try{pstmt.close();}catch(SQLException ee){}
		}
	
		return log_datas;
	}
	
	/**
	 * @author : Kswany 
	 * Account(계정) - account(linux계열) Info 가져오기 View
	 *	key: system_name(가상설정)
	 */
	public HashMap getAccountInfo_windows(String work_no) 
//			throws SQLException {
			throws Exception{

		PreparedStatement pstmt=null;
		ResultSet rs = null;

		HashMap log_info_map = new HashMap();

		try {

			/*
			 *  DB value 값세팅 구현 로직 들어갈 부분
			 */
			// 가상데이터
			log_info_map.put("system_name", "Test001");
			log_info_map.put("id", "Administrator");
			log_info_map.put("group", "__vmware__");
			log_info_map.put("a_attr_", "3");
			log_info_map.put("account_expire_date", "2013-12-31");
			log_info_map.put("pw_max_use_date", "42");
			log_info_map.put("pw_min_use_date", "0");
			log_info_map.put("last_connect_date", "2013-05-06 13:32:19");
			log_info_map.put("last_connect_gear", "TEST_gear");
			log_info_map.put("pw_change_date", "2013-05-06 13:32:19");

			
		}catch (Exception e){
			throw e;
		}finally{
//			if ( rs != null) try{rs.close();}catch(SQLException ee){}
//			if ( pstmt != null) try{pstmt.close();}catch(SQLException ee){}
		}
		
		
		return log_info_map;
	}
	
	
	/**
	 *  @author Kswany
	 * 	Account(계정) - account(DB계열) jqGrid List 가져오기
	 * 
	 *  searchStr: 검색조건
	 *  orderBy: sort조건
	 *  prev_page: first limit 
	 *  next_page: last limit
	 *  
	 * **/
	public List getJqgridAccountList_db(String searchStr, String orderBy, int prev_page, int next_page) 
//			throws SQLException{
			throws Exception{
		PreparedStatement pstmt=null;
		ResultSet rs = null;

		HashMap log_data_map = null;
		List log_datas = new ArrayList();
		
		try{
		/*
		 *  DB value 값세팅 구현 로직 들어갈 부분
		 */
		// 가상데이터
		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("account", "avahi");
		log_data_map.put("status", "시스템계정");
		log_data_map.put("lock", "사용");
		log_data_map.put("expire_date", "2012-04-02");
		log_data_map.put("sync_time", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);
		
		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("account", "avahi");
		log_data_map.put("status", "시스템계정");
		log_data_map.put("lock", "사용");
		log_data_map.put("expire_date", "2012-04-02");
		log_data_map.put("sync_time", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("account", "avahi");
		log_data_map.put("status", "시스템계정");
		log_data_map.put("lock", "사용");
		log_data_map.put("expire_date", "2012-04-02");
		log_data_map.put("sync_time", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("account", "avahi");
		log_data_map.put("status", "시스템계정");
		log_data_map.put("lock", "사용");
		log_data_map.put("expire_date", "2012-04-02");
		log_data_map.put("sync_time", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("account", "avahi");
		log_data_map.put("status", "시스템계정");
		log_data_map.put("lock", "사용");
		log_data_map.put("expire_date", "2012-04-02");
		log_data_map.put("sync_time", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("account", "avahi");
		log_data_map.put("status", "시스템계정");
		log_data_map.put("lock", "사용");
		log_data_map.put("expire_date", "2012-04-02");
		log_data_map.put("sync_time", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("account", "avahi");
		log_data_map.put("status", "시스템계정");
		log_data_map.put("lock", "사용");
		log_data_map.put("expire_date", "2012-04-02");
		log_data_map.put("sync_time", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("account", "avahi");
		log_data_map.put("status", "시스템계정");
		log_data_map.put("lock", "사용");
		log_data_map.put("expire_date", "2012-04-02");
		log_data_map.put("sync_time", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("account", "avahi");
		log_data_map.put("status", "시스템계정");
		log_data_map.put("lock", "사용");
		log_data_map.put("expire_date", "2012-04-02");
		log_data_map.put("sync_time", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("account", "avahi");
		log_data_map.put("status", "시스템계정");
		log_data_map.put("lock", "사용");
		log_data_map.put("expire_date", "2012-04-02");
		log_data_map.put("sync_time", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("account", "avahi");
		log_data_map.put("status", "시스템계정");
		log_data_map.put("lock", "사용");
		log_data_map.put("expire_date", "2012-04-02");
		log_data_map.put("sync_time", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);
		
	//	}catch (SQLException e){
		}catch (Exception e){
			throw e;
		}finally{
	//		if ( rs != null) try{rs.close();}catch(SQLException ee){}
	//		if ( pstmt != null) try{pstmt.close();}catch(SQLException ee){}
		}
	
		return log_datas;
	}
	
	/**
	 *  @author Kswany
	 * 	Account(계정) - account(DB계열) Log jqGrid List 가져오기
	 * 
	 *  searchStr: 검색조건
	 *  orderBy: sort조건
	 *  prev_page: first limit 
	 *  next_page: last limit
	 *  
	 * **/
	public List getJqgridAccountLogList_db(String searchStr, String orderBy, int prev_page, int next_page) 
//			throws SQLException{
			throws Exception{
		PreparedStatement pstmt=null;
		ResultSet rs = null;

		HashMap log_data_map = null;
		List log_datas = new ArrayList();
		
		try{	
		/*
		 *  DB value 값세팅 구현 로직 들어갈 부분
		 */
		// 가상데이터
		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리");
		log_data_map.put("work", "계정정책 변경");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보");
		log_data_map.put("worker", "adadmin");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);
		
		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-12 23:52:11");
		log_data_map.put("type", "계정관리22");
		log_data_map.put("work", "계정정책 변경22");
		log_data_map.put("result", "성공");
		log_data_map.put("important", "정보22");
		log_data_map.put("worker", "adadmin22");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리33");
		log_data_map.put("work", "계정정책 변경33");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보33");
		log_data_map.put("worker", "adadmin33");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리44");
		log_data_map.put("work", "계정정책 변경44");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보44");
		log_data_map.put("worker", "adadmin44");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리");
		log_data_map.put("work", "계정정책 변경");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보");
		log_data_map.put("worker", "adadmin");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리");
		log_data_map.put("work", "계정정책 변경");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보");
		log_data_map.put("worker", "adadmin");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리");
		log_data_map.put("work", "계정정책 변경");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보");
		log_data_map.put("worker", "adadmin");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리");
		log_data_map.put("work", "계정정책 변경");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보");
		log_data_map.put("worker", "adadmin");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리");
		log_data_map.put("work", "계정정책 변경");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보");
		log_data_map.put("worker", "adadmin");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리");
		log_data_map.put("work", "계정정책 변경");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보");
		log_data_map.put("worker", "adadmin");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리");
		log_data_map.put("work", "계정정책 변경");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보");
		log_data_map.put("worker", "adadmin");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);
		
	//	}catch (SQLException e){
		}catch (Exception e){
			throw e;
		}finally{
	//		if ( rs != null) try{rs.close();}catch(SQLException ee){}
	//		if ( pstmt != null) try{pstmt.close();}catch(SQLException ee){}
		}
	
		return log_datas;
	}
	
	/**
	 * @author : Kswany 
	 * Account(계정) - account(DB계열) work Info 가져오기 View
	 *	key: system_name(가상설정)
	 */
	public HashMap getAccountInfo_db(String work_no) 
//			throws SQLException {
			throws Exception{

		PreparedStatement pstmt=null;
		ResultSet rs = null;

		HashMap log_info_map = new HashMap();

		try {

			/*
			 *  DB value 값세팅 구현 로직 들어갈 부분
			 */
			// 가상데이터
			log_info_map.put("system_name", "Test001");
			log_info_map.put("id", "Administrator");
			log_info_map.put("group", "__vmware__");
			log_info_map.put("a_attr_", "3");
			log_info_map.put("account_expire_date", "2013-12-31");
			log_info_map.put("pw_max_used_date", "42");
			log_info_map.put("pw_min_used_date", "0");
			log_info_map.put("last_connect_date", "2013-05-06 13:32:19");
			log_info_map.put("last_connect_gear", "TEST_gear");
			log_info_map.put("pw_change_date", "2013-05-06 13:32:19");
			
		}catch (Exception e){
			throw e;
		}finally{
//			if ( rs != null) try{rs.close();}catch(SQLException ee){}
//			if ( pstmt != null) try{pstmt.close();}catch(SQLException ee){}
		}
		
		
		return log_info_map;
	}
	
	
	/**
	 *  @author Kswany
	 * 	Account(계정) - role(os계열) jqGrid List 가져오기
	 * 
	 *  searchStr: 검색조건
	 *  orderBy: sort조건
	 *  prev_page: first limit 
	 *  next_page: last limit
	 *  
	 * **/
	public List getJqgridRoleList_os(String searchStr, String orderBy, int prev_page, int next_page) 
//			throws SQLException{
			throws Exception{
		PreparedStatement pstmt=null;
		ResultSet rs = null;

		HashMap log_data_map = null;
		List log_datas = new ArrayList();
		
		try{
		/*
		 *  DB value 값세팅 구현 로직 들어갈 부분
		 */
		// 가상데이터
		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("role", "보안그룹1");
		log_data_map.put("status", "동기화");
		log_data_map.put("sync", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);
		
		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("role", "보안그룹2");
		log_data_map.put("status", "동기화");
		log_data_map.put("sync", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("role", "보안그룹3");
		log_data_map.put("status", "동기화");
		log_data_map.put("sync", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("role", "보안그룹4");
		log_data_map.put("status", "동기화");
		log_data_map.put("sync", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("role", "보안그룹5");
		log_data_map.put("status", "동기화");
		log_data_map.put("sync", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("role", "보안그룹1");
		log_data_map.put("status", "동기화");
		log_data_map.put("sync", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("role", "보안그룹1");
		log_data_map.put("status", "동기화");
		log_data_map.put("sync", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("role", "보안그룹1");
		log_data_map.put("status", "동기화");
		log_data_map.put("sync", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("role", "보안그룹1");
		log_data_map.put("status", "동기화");
		log_data_map.put("sync", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("role", "보안그룹1");
		log_data_map.put("status", "동기화");
		log_data_map.put("sync", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("role", "보안그룹1");
		log_data_map.put("status", "동기화");
		log_data_map.put("sync", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);
		
	//	}catch (SQLException e){
		}catch (Exception e){
			throw e;
		}finally{
	//		if ( rs != null) try{rs.close();}catch(SQLException ee){}
	//		if ( pstmt != null) try{pstmt.close();}catch(SQLException ee){}
		}
	
		return log_datas;
	}
	
	/**
	 *  @author Kswany
	 * 	Account(계정) - role(os계열) Log jqGrid List 가져오기
	 * 
	 *  searchStr: 검색조건
	 *  orderBy: sort조건
	 *  prev_page: first limit 
	 *  next_page: last limit
	 *  
	 * **/
	public List getJqgridRoleLogList_os(String searchStr, String orderBy, int prev_page, int next_page) 
//			throws SQLException{
			throws Exception{
		PreparedStatement pstmt=null;
		ResultSet rs = null;

		HashMap log_data_map = null;
		List log_datas = new ArrayList();
		
		try{	
		/*
		 *  DB value 값세팅 구현 로직 들어갈 부분
		 */
		// 가상데이터
		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리");
		log_data_map.put("work", "계정정책 변경");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보");
		log_data_map.put("worker", "adadmin");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);
		
		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-12 23:52:11");
		log_data_map.put("type", "계정관리22");
		log_data_map.put("work", "계정정책 변경22");
		log_data_map.put("result", "성공");
		log_data_map.put("important", "정보22");
		log_data_map.put("worker", "adadmin22");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리33");
		log_data_map.put("work", "계정정책 변경33");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보33");
		log_data_map.put("worker", "adadmin33");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리44");
		log_data_map.put("work", "계정정책 변경44");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보44");
		log_data_map.put("worker", "adadmin44");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리");
		log_data_map.put("work", "계정정책 변경");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보");
		log_data_map.put("worker", "adadmin");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리");
		log_data_map.put("work", "계정정책 변경");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보");
		log_data_map.put("worker", "adadmin");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리");
		log_data_map.put("work", "계정정책 변경");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보");
		log_data_map.put("worker", "adadmin");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리");
		log_data_map.put("work", "계정정책 변경");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보");
		log_data_map.put("worker", "adadmin");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리");
		log_data_map.put("work", "계정정책 변경");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보");
		log_data_map.put("worker", "adadmin");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리");
		log_data_map.put("work", "계정정책 변경");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보");
		log_data_map.put("worker", "adadmin");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리");
		log_data_map.put("work", "계정정책 변경");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보");
		log_data_map.put("worker", "adadmin");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);
		
	//	}catch (SQLException e){
		}catch (Exception e){
			throw e;
		}finally{
	//		if ( rs != null) try{rs.close();}catch(SQLException ee){}
	//		if ( pstmt != null) try{pstmt.close();}catch(SQLException ee){}
		}
	
		return log_datas;
	}
	
	/**
	 * @author : Kswany 
	 * Account(계정) - role(os계열) Info 가져오기 View
	 *	key: system_name(가상설정)
	 */
	public HashMap getRoleInfo_os(String work_no) 
//			throws SQLException {
			throws Exception{

		PreparedStatement pstmt=null;
		ResultSet rs = null;

		HashMap log_info_map = new HashMap();

		try {

			/*
			 *  DB value 값세팅 구현 로직 들어갈 부분
			 */
			// 가상데이터
			log_info_map.put("system_name", "Test001");
			log_info_map.put("role", "보안그룹1");
			log_info_map.put("member", "맴버1");
			log_info_map.put("explanation", "설명입니다");
			log_info_map.put("status", "동기화");
			log_info_map.put("last_sync_date", "2013-01-13 22:52:01");
			
		}catch (Exception e){
			throw e;
		}finally{
//			if ( rs != null) try{rs.close();}catch(SQLException ee){}
//			if ( pstmt != null) try{pstmt.close();}catch(SQLException ee){}
		}
		
		
		return log_info_map;
	}
	
	/**
	 * @author : Kswany 
	 *  Account(계정) - role(os계열) - insertRoleInfo
	 *	key: work_no(가상설정)
	 */
	public boolean insertRoleInfo(String work_no) 
//			throws SQLException {
			throws Exception{

		PreparedStatement pstmt=null;
		ResultSet rs = null;

		boolean result = false;
		try {

			/*
			 *  DB value 값세팅 구현 로직 들어갈 부분
			 */
			// 가상데이터
			result = true;

		}catch (Exception e){
			throw e;
		}finally{
//			if ( rs != null) try{rs.close();}catch(SQLException ee){}
//			if ( pstmt != null) try{pstmt.close();}catch(SQLException ee){}
		}
		return result;
	}
	
	/**
	 * @author : Kswany 
	 * Account(계정) - role(os계열) delete(list checkbox선택후 삭제, 리스트 마지막으로 클릭 한 상세정보에서 삭제)
	 *	key: checked된 key(가상설정)
	 */
	public boolean deleteRole(List array) 
//			throws SQLException {
			throws Exception{

		PreparedStatement pstmt=null;
		ResultSet rs = null;

		boolean result = false;
		try {
	
			/*
			 *  DB value 값세팅 구현 로직 들어갈 부분(list의 key값들  where 조건 대입하여 삭제)
			 */
			// 가상데이터
			result = true;

		}catch (Exception e){
			throw e;
		}finally{
//			if ( rs != null) try{rs.close();}catch(SQLException ee){}
//			if ( pstmt != null) try{pstmt.close();}catch(SQLException ee){}
		}
		return result;
	}
	
	/**
	 *  @author Kswany
	 * 	Account(계정) - role(db계열) jqGrid List 가져오기
	 * 
	 *  searchStr: 검색조건
	 *  orderBy: sort조건
	 *  prev_page: first limit 
	 *  next_page: last limit
	 *  
	 * **/
	public List getJqgridRoleList_db(String searchStr, String orderBy, int prev_page, int next_page) 
//			throws SQLException{
			throws Exception{
		PreparedStatement pstmt=null;
		ResultSet rs = null;

		HashMap log_data_map = null;
		List log_datas = new ArrayList();
		
		try{
		/*
		 *  DB value 값세팅 구현 로직 들어갈 부분
		 */
		// 가상데이터
		log_data_map = new HashMap();
		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("role", "보안그룹1");
		log_data_map.put("status", "동기화");
		log_data_map.put("sync", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);
		
		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("role", "보안그룹2");
		log_data_map.put("status", "동기화");
		log_data_map.put("sync", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("role", "보안그룹3");
		log_data_map.put("status", "동기화");
		log_data_map.put("sync", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("role", "보안그룹4");
		log_data_map.put("status", "동기화");
		log_data_map.put("sync", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("role", "보안그룹5");
		log_data_map.put("status", "동기화");
		log_data_map.put("sync", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("role", "보안그룹1");
		log_data_map.put("status", "동기화");
		log_data_map.put("sync", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("role", "보안그룹1");
		log_data_map.put("status", "동기화");
		log_data_map.put("sync", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("role", "보안그룹1");
		log_data_map.put("status", "동기화");
		log_data_map.put("sync", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("role", "보안그룹1");
		log_data_map.put("status", "동기화");
		log_data_map.put("sync", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("role", "보안그룹1");
		log_data_map.put("status", "동기화");
		log_data_map.put("sync", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("role", "보안그룹1");
		log_data_map.put("status", "동기화");
		log_data_map.put("sync", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);
		
	//	}catch (SQLException e){
		}catch (Exception e){
			throw e;
		}finally{
	//		if ( rs != null) try{rs.close();}catch(SQLException ee){}
	//		if ( pstmt != null) try{pstmt.close();}catch(SQLException ee){}
		}
	
		return log_datas;
	}
	
	/**
	 *  @author Kswany
	 * 	Work(작업) - Account(계정) - role(db계열) Log jqGrid List 가져오기
	 * 
	 *  searchStr: 검색조건
	 *  orderBy: sort조건
	 *  prev_page: first limit 
	 *  next_page: last limit
	 *  
	 * **/
	public List getJqgridRoleLogList_db(String searchStr, String orderBy, int prev_page, int next_page) 
//			throws SQLException{
			throws Exception{
		PreparedStatement pstmt=null;
		ResultSet rs = null;

		HashMap log_data_map = null;
		List log_datas = new ArrayList();
		
		try{	
		/*
		 *  DB value 값세팅 구현 로직 들어갈 부분
		 */
		// 가상데이터
		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리");
		log_data_map.put("work", "계정정책 변경");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보");
		log_data_map.put("worker", "adadmin");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);
		
		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-12 23:52:11");
		log_data_map.put("type", "계정관리22");
		log_data_map.put("work", "계정정책 변경22");
		log_data_map.put("result", "성공");
		log_data_map.put("important", "정보22");
		log_data_map.put("worker", "adadmin22");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리33");
		log_data_map.put("work", "계정정책 변경33");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보33");
		log_data_map.put("worker", "adadmin33");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리44");
		log_data_map.put("work", "계정정책 변경44");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보44");
		log_data_map.put("worker", "adadmin44");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리");
		log_data_map.put("work", "계정정책 변경");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보");
		log_data_map.put("worker", "adadmin");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리");
		log_data_map.put("work", "계정정책 변경");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보");
		log_data_map.put("worker", "adadmin");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리");
		log_data_map.put("work", "계정정책 변경");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보");
		log_data_map.put("worker", "adadmin");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리");
		log_data_map.put("work", "계정정책 변경");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보");
		log_data_map.put("worker", "adadmin");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리");
		log_data_map.put("work", "계정정책 변경");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보");
		log_data_map.put("worker", "adadmin");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리");
		log_data_map.put("work", "계정정책 변경");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보");
		log_data_map.put("worker", "adadmin");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리");
		log_data_map.put("work", "계정정책 변경");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보");
		log_data_map.put("worker", "adadmin");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);
		
	//	}catch (SQLException e){
		}catch (Exception e){
			throw e;
		}finally{
	//		if ( rs != null) try{rs.close();}catch(SQLException ee){}
	//		if ( pstmt != null) try{pstmt.close();}catch(SQLException ee){}
		}
	
		return log_datas;
	}
	
	/**
	 * @author : Kswany 
	 * Account(계정) - role(db계열) Info 가져오기 View
	 *	key: system_name(가상설정)
	 */
	public HashMap getRoleInfo_db(String work_no) 
//			throws SQLException {
			throws Exception{

		PreparedStatement pstmt=null;
		ResultSet rs = null;

		HashMap log_info_map = new HashMap();

		try {

			/*
			 *  DB value 값세팅 구현 로직 들어갈 부분
			 */
			// 가상데이터
			log_info_map.put("system_name", "Test001");
			log_info_map.put("role", "ADM_PARALLEL_EXECUTE_TASK");
			log_info_map.put("status", "동기화");
			log_info_map.put("sync_date", "2013-01-13 22:52:01");

		}catch (Exception e){
			throw e;
		}finally{
//			if ( rs != null) try{rs.close();}catch(SQLException ee){}
//			if ( pstmt != null) try{pstmt.close();}catch(SQLException ee){}
		}
		
		
		return log_info_map;
	}

	/**
	 * @author : Kswany 
	 * Account(계정) - role insert
	 *	key: system_name(가상설정)
	 */
	public boolean insertRoleAdd(HashMap param) 
//			throws SQLException {
			throws Exception{

		PreparedStatement pstmt=null;
		ResultSet rs = null;

		HashMap log_info_map = new HashMap();
		boolean result = false;
		try {

			String insert_group = String.valueOf(param.get("system_name"));
			String user = String.valueOf(param.get("lock_group_name"));
			String name = String.valueOf(param.get("target_list"));
			String pw = String.valueOf(param.get("lock_group_ex"));

			/*
			 *  DB value 값세팅 구현 로직 들어갈 부분
			 */
			// 가상데이터
			result = true;

		}catch (Exception e){
			throw e;
		}finally{
//			if ( rs != null) try{rs.close();}catch(SQLException ee){}
//			if ( pstmt != null) try{pstmt.close();}catch(SQLException ee){}
		}
		return result;
	}
	
	
	/**
	 * @author : Kswany 
	 * Account(계정) - role  Group 중복체크
	 *	key: lock_group_name(가상설정)
	 */
	public boolean checkRole(String lock_group_name) 
	//	throws SQLException {
		throws Exception{
	
		PreparedStatement pstmt=null;
		ResultSet rs = null;
		
		boolean result = false;
		try {
		
			/*
			 *  DB value 값세팅 구현 로직 들어갈 부분(list의 key값들  where 조건 대입하여 삭제)
			 */
			// 가상데이터
			result = true;//사용할수 있을때 true, 없을때 false
		
		}catch (Exception e){
			throw e;
		}finally{
		//	if ( rs != null) try{rs.close();}catch(SQLException ee){}
		//	if ( pstmt != null) try{pstmt.close();}catch(SQLException ee){}
		}
		return result;
	}
	
	/**
	 *  @author Kswany
	 * 	Account(계정) - group jqGrid List 가져오기
	 * 
	 *  searchStr: 검색조건
	 *  orderBy: sort조건
	 *  prev_page: first limit 
	 *  next_page: last limit
	 *  
	 * **/
	public List getJqgridGroupList(String searchStr, String orderBy, int prev_page, int next_page) 
//			throws SQLException{
			throws Exception{
		PreparedStatement pstmt=null;
		ResultSet rs = null;

		HashMap log_data_map = null;
		List log_datas = new ArrayList();
		
		try{
		/*
		 *  DB value 값세팅 구현 로직 들어갈 부분
		 */
		// 가상데이터
		log_data_map = new HashMap();
		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("role", "보안그룹1");
		log_data_map.put("status", "동기화");
		log_data_map.put("sync", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);
		
		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("role", "보안그룹2");
		log_data_map.put("status", "동기화");
		log_data_map.put("sync", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("role", "보안그룹3");
		log_data_map.put("status", "동기화");
		log_data_map.put("sync", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("role", "보안그룹4");
		log_data_map.put("status", "동기화");
		log_data_map.put("sync", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("role", "보안그룹5");
		log_data_map.put("status", "동기화");
		log_data_map.put("sync", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("role", "보안그룹1");
		log_data_map.put("status", "동기화");
		log_data_map.put("sync", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("role", "보안그룹1");
		log_data_map.put("status", "동기화");
		log_data_map.put("sync", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("role", "보안그룹1");
		log_data_map.put("status", "동기화");
		log_data_map.put("sync", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("role", "보안그룹1");
		log_data_map.put("status", "동기화");
		log_data_map.put("sync", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("role", "보안그룹1");
		log_data_map.put("status", "동기화");
		log_data_map.put("sync", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("system_name", "redhat");
		log_data_map.put("role", "보안그룹1");
		log_data_map.put("status", "동기화");
		log_data_map.put("sync", "2013-05-17 16:11:11");
		log_datas.add(log_data_map);
		
	//	}catch (SQLException e){
		}catch (Exception e){
			throw e;
		}finally{
	//		if ( rs != null) try{rs.close();}catch(SQLException ee){}
	//		if ( pstmt != null) try{pstmt.close();}catch(SQLException ee){}
		}
	
		return log_datas;
	}
	
	/**
	 *  @author Kswany
	 * 	Account(계정) - group jqGrid Log List 가져오기
	 * 
	 *  searchStr: 검색조건
	 *  orderBy: sort조건
	 *  prev_page: first limit 
	 *  next_page: last limit
	 *  
	 * **/
	public List getJqgridGroupLogList(String searchStr, String orderBy, int prev_page, int next_page) 
//			throws SQLException{
			throws Exception{
		PreparedStatement pstmt=null;
		ResultSet rs = null;

		HashMap log_data_map = null;
		List log_datas = new ArrayList();
		
		try{	
		/*
		 *  DB value 값세팅 구현 로직 들어갈 부분
		 */
		// 가상데이터
		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리");
		log_data_map.put("work", "계정정책 변경");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보");
		log_data_map.put("worker", "adadmin");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);
		
		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-12 23:52:11");
		log_data_map.put("type", "계정관리22");
		log_data_map.put("work", "계정정책 변경22");
		log_data_map.put("result", "성공");
		log_data_map.put("important", "정보22");
		log_data_map.put("worker", "adadmin22");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리33");
		log_data_map.put("work", "계정정책 변경33");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보33");
		log_data_map.put("worker", "adadmin33");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리44");
		log_data_map.put("work", "계정정책 변경44");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보44");
		log_data_map.put("worker", "adadmin44");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리");
		log_data_map.put("work", "계정정책 변경");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보");
		log_data_map.put("worker", "adadmin");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리");
		log_data_map.put("work", "계정정책 변경");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보");
		log_data_map.put("worker", "adadmin");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리");
		log_data_map.put("work", "계정정책 변경");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보");
		log_data_map.put("worker", "adadmin");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리");
		log_data_map.put("work", "계정정책 변경");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보");
		log_data_map.put("worker", "adadmin");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리");
		log_data_map.put("work", "계정정책 변경");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보");
		log_data_map.put("worker", "adadmin");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리");
		log_data_map.put("work", "계정정책 변경");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보");
		log_data_map.put("worker", "adadmin");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);

		log_data_map = new HashMap();
		log_data_map.put("calender", "2013-01-13 22:52:01");
		log_data_map.put("type", "계정관리");
		log_data_map.put("work", "계정정책 변경");
		log_data_map.put("result", "실패");
		log_data_map.put("important", "정보");
		log_data_map.put("worker", "adadmin");
		log_data_map.put("ip_addr", "192.168.1.1");
		log_datas.add(log_data_map);
		
	//	}catch (SQLException e){
		}catch (Exception e){
			throw e;
		}finally{
	//		if ( rs != null) try{rs.close();}catch(SQLException ee){}
	//		if ( pstmt != null) try{pstmt.close();}catch(SQLException ee){}
		}
	
		return log_datas;
	}
	
	/**
	 * @author : Kswany 
	 * Account(계정) - group Info 가져오기 View
	 *	key: system_name(가상설정)
	 */
	public HashMap getGroupInfo(String work_no) 
//			throws SQLException {
			throws Exception{

		PreparedStatement pstmt=null;
		ResultSet rs = null;

		HashMap log_info_map = new HashMap();

		try {

			/*
			 *  DB value 값세팅 구현 로직 들어갈 부분
			 */
			// 가상데이터
			log_info_map.put("system_name", "Test001");
			log_info_map.put("group_name", "ADM_PARALLEL_EXECUTE_TASK");
			log_info_map.put("group_auth", "test권한");
			log_info_map.put("status", "동기화");
			log_info_map.put("sync_date", "2013-01-13 22:52:01");

		}catch (Exception e){
			throw e;
		}finally{
//			if ( rs != null) try{rs.close();}catch(SQLException ee){}
//			if ( pstmt != null) try{pstmt.close();}catch(SQLException ee){}
		}
		
		
		return log_info_map;
	}
	
	/**
	 * @author : Kswany 
	 *  Account(계정) - group - insertRoleInfo
	 *	key: work_no(가상설정)
	 */
	public boolean insertGroupInfo(String work_no) 
//			throws SQLException {
			throws Exception{

		PreparedStatement pstmt=null;
		ResultSet rs = null;

		boolean result = false;
		try {

			/*
			 *  DB value 값세팅 구현 로직 들어갈 부분
			 */
			// 가상데이터
			result = true;

		}catch (Exception e){
			throw e;
		}finally{
//			if ( rs != null) try{rs.close();}catch(SQLException ee){}
//			if ( pstmt != null) try{pstmt.close();}catch(SQLException ee){}
		}
		return result;
	}
	
	/**
	 * @author : Kswany 
	 *  Account(계정) - group insert
	 *	key: system_name(가상설정)
	 */
	public boolean insertGroupAdd(HashMap param) 
//			throws SQLException {
			throws Exception{

		PreparedStatement pstmt=null;
		ResultSet rs = null;

		HashMap log_info_map = new HashMap();
		boolean result = false;
		try {

			String insert_group = String.valueOf(param.get("system_name"));
			String user = String.valueOf(param.get("group_name"));
			String name = String.valueOf(param.get("group_auth"));
			String pw = String.valueOf(param.get("group_ex"));

			/*
			 *  DB value 값세팅 구현 로직 들어갈 부분
			 */
			// 가상데이터
			result = true;

		}catch (Exception e){
			throw e;
		}finally{
//			if ( rs != null) try{rs.close();}catch(SQLException ee){}
//			if ( pstmt != null) try{pstmt.close();}catch(SQLException ee){}
		}
		return result;
	}
	
	
	/**
	 * @author : Kswany 
	 * Account(계정) - group  Group 중복체크
	 *	key: group_name(가상설정)
	 */
	public boolean checkGroup(String group_name) 
	//	throws SQLException {
		throws Exception{
	
		PreparedStatement pstmt=null;
		ResultSet rs = null;
		
		boolean result = false;
		try {
		
			/*
			 *  DB value 값세팅 구현 로직 들어갈 부분(list의 key값들  where 조건 대입하여 삭제)
			 */
			// 가상데이터
			result = true;//사용할수 있을때 true, 없을때 false
		
		}catch (Exception e){
			throw e;
		}finally{
		//	if ( rs != null) try{rs.close();}catch(SQLException ee){}
		//	if ( pstmt != null) try{pstmt.close();}catch(SQLException ee){}
		}
		return result;
	}
	
	
	/**
	 * @author : Kswany 
	 * Account(계정) - group delete(list checkbox선택후 삭제, 리스트 마지막으로 클릭 한 상세정보에서 삭제)
	 *	key: checked된 key(가상설정)
	 */
	public boolean deleteGroup(List array) 
//			throws SQLException {
			throws Exception{

		PreparedStatement pstmt=null;
		ResultSet rs = null;

		boolean result = false;
		try {
	
			/*
			 *  DB value 값세팅 구현 로직 들어갈 부분(list의 key값들  where 조건 대입하여 삭제)
			 */
			// 가상데이터
			result = true;

		}catch (Exception e){
			throw e;
		}finally{
//			if ( rs != null) try{rs.close();}catch(SQLException ee){}
//			if ( pstmt != null) try{pstmt.close();}catch(SQLException ee){}
		}
		return result;
	}
	
	
	
	/**
	 * @author : Kswany 
	 * 공통  Info member insert
	 * 
	 */
	public boolean insertMember(HashMap param) 
//			throws SQLException {
			throws Exception{

		PreparedStatement pstmt=null;
		ResultSet rs = null;

		boolean result = false;
		try {
			String member = String.valueOf(param.get("member"));
			String member_type = String.valueOf(param.get("member_type"));
			
			/*
			 *  DB value 값세팅 구현 로직 들어갈 부분(list의 key값들  where 조건 대입하여 삭제)
			 */
			// 가상데이터
			result = true;

		}catch (Exception e){
			throw e;
		}finally{
//			if ( rs != null) try{rs.close();}catch(SQLException ee){}
//			if ( pstmt != null) try{pstmt.close();}catch(SQLException ee){}
		}
		return result;
	}
	
	
	/**
	 * @author : Kswany 
	 * 공통  Info member delete
	 * 
	 */
	public boolean deleteMember(HashMap param) 
//			throws SQLException {
			throws Exception{

		PreparedStatement pstmt=null;
		ResultSet rs = null;

		boolean result = false;
		try {
			String param1 = String.valueOf(param.get("param"));
			
			/*
			 *  DB value 값세팅 구현 로직 들어갈 부분(list의 key값들  where 조건 대입하여 삭제)
			 */
			// 가상데이터
			result = true;

		}catch (Exception e){
			throw e;
		}finally{
//			if ( rs != null) try{rs.close();}catch(SQLException ee){}
//			if ( pstmt != null) try{pstmt.close();}catch(SQLException ee){}
		}
		return result;
	}
	
	
	/**
	 * @author : Kswany 
	 * 역할 popup 시스템명 + insert
	 * 
	 */
	public boolean insertSystem(HashMap param) 
//			throws SQLException {
			throws Exception{

		PreparedStatement pstmt=null;
		ResultSet rs = null;

		boolean result = false;
		try {
			String member = String.valueOf(param.get("target_list"));
			String member_type = String.valueOf(param.get("system_type"));
			
			/*
			 *  DB value 값세팅 구현 로직 들어갈 부분(list의 key값들  where 조건 대입하여 삭제)
			 */
			// 가상데이터
			result = true;

		}catch (Exception e){
			throw e;
		}finally{
//			if ( rs != null) try{rs.close();}catch(SQLException ee){}
//			if ( pstmt != null) try{pstmt.close();}catch(SQLException ee){}
		}
		return result;
	}
	
	
	/**
	 * @author : Kswany 
	 * 역할 popup 시스템명 - delete
	 * 
	 */
	public boolean deleteSystem(HashMap param) 
//			throws SQLException {
			throws Exception{

		PreparedStatement pstmt=null;
		ResultSet rs = null;

		boolean result = false;
		try {
			String member = String.valueOf(param.get("target_list"));
			String member_type = String.valueOf(param.get("system_type"));
			
			/*
			 *  DB value 값세팅 구현 로직 들어갈 부분(list의 key값들  where 조건 대입하여 삭제)
			 */
			// 가상데이터
			result = true;

		}catch (Exception e){
			throw e;
		}finally{
//			if ( rs != null) try{rs.close();}catch(SQLException ee){}
//			if ( pstmt != null) try{pstmt.close();}catch(SQLException ee){}
		}
		return result;
	}
	
	
	/**
	 * @author : Kswany 
	 * 계정 popup 시스템명 + insert
	 * 
	 */
	public boolean insertSystemName(HashMap param) 
//			throws SQLException {
			throws Exception{

		PreparedStatement pstmt=null;
		ResultSet rs = null;

		boolean result = false;
		try {
			String insert_system = String.valueOf(param.get("insert_system"));
			String system_name = String.valueOf(param.get("system_name"));
			
			/*
			 *  DB value 값세팅 구현 로직 들어갈 부분(list의 key값들  where 조건 대입하여 삭제)
			 */
			// 가상데이터
			result = true;

		}catch (Exception e){
			throw e;
		}finally{
//			if ( rs != null) try{rs.close();}catch(SQLException ee){}
//			if ( pstmt != null) try{pstmt.close();}catch(SQLException ee){}
		}
		return result;
	}
	
	
	/**
	 * @author : Kswany 
	 * 계정 popup 시스템명 - delete
	 * 
	 */
	public boolean deleteSystemName(HashMap param) 
//			throws SQLException {
			throws Exception{

		PreparedStatement pstmt=null;
		ResultSet rs = null;

		boolean result = false;
		try {
			String insert_system = String.valueOf(param.get("insert_system"));
			String system_name = String.valueOf(param.get("system_name"));
			
			/*
			 *  DB value 값세팅 구현 로직 들어갈 부분(list의 key값들  where 조건 대입하여 삭제)
			 */
			// 가상데이터
			result = true;

		}catch (Exception e){
			throw e;
		}finally{
//			if ( rs != null) try{rs.close();}catch(SQLException ee){}
//			if ( pstmt != null) try{pstmt.close();}catch(SQLException ee){}
		}
		return result;
	}
	
	/**
	 * @author : Kswany 
	 * account window group + insert
	 * 
	 */
	public boolean insertGroup(HashMap param) 
//			throws SQLException {
			throws Exception{

		PreparedStatement pstmt=null;
		ResultSet rs = null;

		boolean result = false;
		try {
			String group = String.valueOf(param.get("group"));
			String system_type = String.valueOf(param.get("system_type"));
			
			/*
			 *  DB value 값세팅 구현 로직 들어갈 부분(list의 key값들  where 조건 대입하여 삭제)
			 */
			// 가상데이터
			result = true;

		}catch (Exception e){
			throw e;
		}finally{
//			if ( rs != null) try{rs.close();}catch(SQLException ee){}
//			if ( pstmt != null) try{pstmt.close();}catch(SQLException ee){}
		}
		return result;
	}
	
	
	/**
	 * @author : Kswany 
	 * account window group - delete
	 * 
	 */
	public boolean deleteGroup(HashMap param) 
//			throws SQLException {
			throws Exception{

		PreparedStatement pstmt=null;
		ResultSet rs = null;

		boolean result = false;
		try {
			String group = String.valueOf(param.get("group"));
			String system_type = String.valueOf(param.get("system_type"));
			
			/*
			 *  DB value 값세팅 구현 로직 들어갈 부분(list의 key값들  where 조건 대입하여 삭제)
			 */
			// 가상데이터
			result = true;

		}catch (Exception e){
			throw e;
		}finally{
//			if ( rs != null) try{rs.close();}catch(SQLException ee){}
//			if ( pstmt != null) try{pstmt.close();}catch(SQLException ee){}
		}
		return result;
	}
}
